home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Agent Central Host Computer
/
Agent - Central Host Computer.iso
/
_SETUP.1
/
probehist.sql
< prev
next >
Wrap
Text File
|
2000-05-12
|
1KB
|
24 lines
/* RCSVER $Id: probehist.sql,v 1.2 1999-04-05 19:07:19-05 randy CURRENT $ */
/* *************************************************************************
* Copyright (C) 1999, Agent Systems, Inc. All Rights Reserved.
*
* Name: probehist.sql
* Date: 02/23/1999
* memo: Randy Wood
* Description: Create the probehist.sql. Probehist will contain information
* about probing from the GRS. Probe information from the actual
* probed data will be stored in the fbprobe table.
* Changes:
************************************************************************* */
CREATE TABLE probehist
(
farebox_glid NUMBER(38), /* ID of farebox */
pdate DATE, /* Date of probe */
cbintent NUMBER(38), /* Intent to pull: 1:pull 0:not */
probe_seq NUMBER(38), /* Probe sequence number */
location_glid NUMBER(38), /* Location of probing */
user_id VARCHAR2(80), /* User respons. for probing */
conversion_num NUMBER(38), /* Conversion num from convert table */
CONSTRAINT pk_probehist PRIMARY KEY (conversion_num)
);